How to: Delete a cell from a worksheet.
Solution:
Select the cell and select 'Delete...' from the 'Edit' menu.
1) Click on the cell to delete.
NOTE: To delete multiple cells, highlight the cells in the worksheet.
2) Select the 'Edit' menu and select 'Delete...'. (The Delete dialog box appears.)
NOTE: Alternatively, select the cell, click on the right mouse button, and select 'Delete...' from the shortcut menu.
3) Do one of the following:
a) Select the 'Shift Cells Left' radio button to move the next cell in the same row to fill the space left by the deleted cell.
b) Select the 'Shift Cells Up' radio button to move the next cell in the same column to fill the space left by the deleted cell.
4) Click 'OK'.